        var mysql      = require('mysql');
        var connection = mysql.createConnection({
          host     : '47.96.159.157',
          user     : 'root',
          password : 'jN+100][',
          database : 'ksAppDB',
          port:'3306'
        });

        connection.connect();
        var sql='SELECT c.*,s.* FROM Class c LEFT JOIN `Subject` s ON c.subject_id=s.subject_id WHERE c.class_id in('+
				'SELECT class_id FROM UserClass WHERE openId=\'10656\');';
        connection.query(sql, function (error, results, fields) {
			//
			console.log(results[0].node_start);
			console.log(results[0].node_split);
			console.log(results[0].node_end);
			console.log("====================");

			var myDate=new Date()
			myDate.setFullYear(2008,7,9)
			console.log(DateStart2End(results[0].node_start,results[0].node_split,0));
			console.log("====================");
			console.log(DateStart2End(results[0].node_split,results[0].node_end,1));
			//
        });//end connection.query


Date.prototype.Format = function (fmt) { //author: meizz 
    var o = {
        "M+": this.getMonth() + 1, //月份 
        "d+": this.getDate(), //日 
        "h+": this.getHours(), //小时 
        "m+": this.getMinutes(), //分 
        "s+": this.getSeconds(), //秒 
        "q+": Math.floor((this.getMonth() + 3) / 3), //季度 
        "S": this.getMilliseconds() //毫秒 
    };
    if (/(y+)/.test(fmt)) fmt = fmt.replace(RegExp.$1, (this.getFullYear() + "").substr(4 - RegExp.$1.length));
    for (var k in o)
    if (new RegExp("(" + k + ")").test(fmt)) fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
    return fmt;
}
function DateStart2End(node_start,node_end,day){
	var oneDayTime = 24*60*60*1000;
	var list = [];
	var dateS=new Date(node_start).getTime()+(oneDayTime*day);
	var dateE=new Date(node_end).getTime();
	for(var i=dateS;i<dateE;i+=oneDayTime){
		list.push(new Date(i).Format('yyyy-MM-dd'));
	}
	return list;
}